﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ExportExcelForm.aspx.cs" Inherits="UILGestion.Rpt.ExportExcelForm" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
       <form id="form1" runat="server">
        <input id="idObra" type="hidden" runat="server" />
        <input id="idProyecto" type="hidden" runat="server" />
        
    <input id="type" type="hidden" runat="server" />
 
 

        <asp:GridView ID="GridView1" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
                <asp:BoundField DataField = "FR" HeaderText = "FR"  />
                <asp:BoundField DataField = "fecha" HeaderText = "FECHA EMISION" HeaderStyle-Width="80px"/>
                <asp:BoundField DataField = "tipoDocumento" HeaderText = "T/D"  />
                <asp:BoundField DataField = "numDoc" HeaderText = "NUM. DOCUMENTO"  />
                <asp:BoundField DataField = "beneficiario" HeaderText = "BENERIFICIARIO"  />
                <asp:BoundField DataField = "concepto" HeaderText = "CONCEPTO" />
                <asp:BoundField DataField = "costoSol" HeaderText = "COSTO SOLES"   HeaderStyle-Width="60px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "netoSol" HeaderText = "NETO SOLES"   HeaderStyle-Width="60px" ItemStyle-BackColor="LightYellow" />
                <asp:BoundField DataField = "reta4taSol" HeaderText = "RETENSION SOLES"   HeaderStyle-Width="80px" ItemStyle-BackColor="LightYellow" />

                <asp:BoundField DataField = "IGVSol" HeaderText = "IGV SOLES"  HeaderStyle-Width="60px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "totalSol" HeaderText = "TOTAL SOLES"   HeaderStyle-Width="60px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "tipoCambio" HeaderText = "T/C"  />
                <asp:BoundField DataField = "costoDolar" HeaderText = "COSTO DOLARES"   HeaderStyle-Width="80px" ItemStyle-BackColor="AliceBlue"/>

                <asp:BoundField DataField = "netoDolar" HeaderText = "NETO DOLARES"   HeaderStyle-Width="80px" ItemStyle-BackColor="LightYellow" />
                <asp:BoundField DataField = "reta4taDolar" HeaderText = "RETENSION DOLARES"   HeaderStyle-Width="80px" ItemStyle-BackColor="LightYellow" />

                
                <asp:BoundField DataField = "IGVDolar" HeaderText = "IGV DOLARES"  HeaderStyle-Width="80px" ItemStyle-BackColor="AliceBlue"/>
                <asp:BoundField DataField = "totalDolar" HeaderText = "TOTAL DOLARES"   HeaderStyle-Width="80px" ItemStyle-BackColor="AliceBlue" />
                <asp:BoundField DataField = "fechaVenc" HeaderText = "FECHA VENCIMIENTO" HeaderStyle-Width="90px"  />
                
               
               
            </Columns> 
        </asp:GridView>


        
        <asp:GridView ID="GridView2" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
                <asp:BoundField DataField = "CODIGO" HeaderText = "CODIGO" DataFormatString="" />
                <asp:BoundField DataField = "COMPARATIVO" HeaderText = "COMPARATIVO" />
                <asp:BoundField DataField = "ESTADO" HeaderText = "ESTADO" HeaderStyle-Width="110px" />
                <asp:BoundField DataField = "ESTRUCTURA" HeaderText = "ESTRUCTURA"  />
                <asp:BoundField DataField = "FECHA" HeaderStyle-Width="80px" HeaderText = "FECHA"  />
                <asp:BoundField DataField = "FECHA_APROStr" HeaderStyle-Width="85px" HeaderText = "FECHA APROBACION" />
                
                <asp:BoundField DataField = "PROVEEDOR" HeaderText = "PROVEEDOR"  />
                <asp:BoundField DataField = "TIPOCAMBIO" HeaderText = "TIPO CAMBIO"  HeaderStyle-Width="80px" />
                <asp:BoundField DataField = "MONEDA" HeaderText = "MONEDA"    HeaderStyle-Width="60px" />
                <asp:BoundField DataField = "MONTOBASE" HeaderText = "MONTO BASE"  HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "MONTOCONTRATADO" HeaderText = "MONTO CONTRATADO"   HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "SALDODISPONIBLE" HeaderText = "SALDO DISPONIBLE"   HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow"/> 
               
               
            </Columns> 
        </asp:GridView>


           
        <asp:GridView ID="GridView3" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
                <asp:BoundField DataField = "numDocumento" HeaderText = "NUM. DOCUMENTO" DataFormatString="" />
                <asp:BoundField DataField = "fecha" HeaderText = "FECHA" />
                <asp:BoundField DataField = "ruc" HeaderText = "RUC" HeaderStyle-Width="100px" />
                <asp:BoundField DataField = "proveedor" HeaderText = "PROVEEDOR"  />
                <asp:BoundField DataField = "formaPago" HeaderText = "FORMA PAGO"  />
                <asp:BoundField DataField = "estado" HeaderStyle-Width="80px" HeaderText = "ESTADO"  />
                <asp:BoundField DataField = "moneda" HeaderText = "MONEDA"    HeaderStyle-Width="60px" />
                <asp:BoundField DataField = "subtotal"  HeaderText = "SUB TOTAL" HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "igv"  HeaderText = "IGV" HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "total"  HeaderText = "TOTAL" HeaderStyle-Width="90px" ItemStyle-BackColor="LightGoldenrodYellow" />
                
                <asp:BoundField DataField = "autorizado" HeaderText = "AUTORIZADO"    />
                <asp:BoundField DataField = "comparativo" HeaderText = "COMPARATIVO"  />
                <asp:BoundField DataField = "estructuraCosto" HeaderText = "ESTRUCTURA" />
                
                <asp:BoundField DataField = "observacion" HeaderText = "OBSERVACION"   /> 
                <asp:BoundField DataField = "observacionInter" HeaderText = "OBSERVACION INTERNA."   /> 
               
               
            </Columns> 
        </asp:GridView>


               
         <asp:GridView ID="GridView4" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "codigo" HeaderText = "CODIGO"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "caracteristica" HeaderText = "CARACTERISTCA"  />
                <asp:BoundField DataField = "tipoModelo" HeaderText = "MODELO"  />
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO"  />
                <asp:BoundField DataField = "plazoEntrega" HeaderText = "PLAZO ENTREGA"  />
                <asp:BoundField DataField = "fechaEntrega" HeaderText = "FECHA ENTREGA"  />
                
                <asp:BoundField DataField = "direccion" HeaderText = "DIRECCION"    />
                <asp:BoundField DataField = "referencia" HeaderText = "REFERENCIA"  />
                <asp:BoundField DataField = "descripcion" HeaderText = "DPTO"    ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "urbanizacion" HeaderText = "URBANIZACION"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "piso" HeaderText = "PISO"   ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  ItemStyle-BackColor="LightGoldenrodYellow" />

                <asp:BoundField DataField = "areaTerreno" HeaderText = "AREA TERRENO"    />
                <asp:BoundField DataField = "areaTechada" HeaderText = "AREA TECHADA"  />
                <asp:BoundField DataField = "areaOcupada" HeaderText = "AREA OCUPADA"    />
                <asp:BoundField DataField = "numPartida" HeaderText = "NUM. PARTIDA"  />
                
                <asp:BoundField DataField = "frente" HeaderText = "FRENTE"    />
                <asp:BoundField DataField = "derecho" HeaderText = "DERECHO"  />
                <asp:BoundField DataField = "izquierdo" HeaderText = "IZQUIERDO"    />
                <asp:BoundField DataField = "fondo" HeaderText = "FONDO"  />
                
                <asp:BoundField DataField = "dormitorio" HeaderText = "DORMITORIO" />
                <asp:BoundField DataField = "banio" HeaderText = "BAÑO"   /> 
                <asp:BoundField DataField = "precio" HeaderText = "PRECIO"   ItemStyle-BackColor="LightGoldenrodYellow"/> 
                <%--<asp:BoundField DataField = "observacion" HeaderText = "OBSERVACION"  ItemStyle-BackColor="LightGoldenrodYellow"/>--%>
                <asp:BoundField DataField = "comentario" HeaderText = "COMENTARIO"  />
                <asp:BoundField DataField = "activo" HeaderText = "ACTIVO"  />
               
            </Columns> 
        </asp:GridView>



            <asp:GridView ID="GridView5" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "codigo" HeaderText = "CODIGO"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "caracteristica" HeaderText = "CARACTERISTCA"  />
                <asp:BoundField DataField = "tipoModelo" HeaderText = "TIPO MODELO"  />
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "plazoEntrega" HeaderText = "PLAZO ENTREGA"  />
                <asp:BoundField DataField = "fechaEntrega" HeaderText = "FECHA ENTREGA"  />


                <asp:BoundField DataField = "direccion" HeaderText = "DIRECCION"  />
                <asp:BoundField DataField = "referencia" HeaderText = "REFERENCIA"  />
                <asp:BoundField DataField = "descripcion" HeaderText = "LOTE"  />
                <asp:BoundField DataField = "urbanizacion" HeaderText = "URBANIZACIÓN"  />
                <asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION" ItemStyle-BackColor="LightGoldenrodYellow"  />
                <asp:BoundField DataField = "piso" HeaderText = "BLOQUE" ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  ItemStyle-BackColor="LightGoldenrodYellow"/>

                <asp:BoundField DataField = "areaTerreno" HeaderText = "AREA TERRENO"  />
                <asp:BoundField DataField = "areaTechada" HeaderText = "AREA TECHADA"  />
                <asp:BoundField DataField = "areaOcupada" HeaderText = "AREA OCUPADA"  />
                <asp:BoundField DataField = "numPartida" HeaderText = "NUM. PARTIDA"  />
                

                
                <asp:BoundField DataField = "frente" HeaderText = "FRENTE"  />
                <asp:BoundField DataField = "derecho" HeaderText = "DERECHO"  />
                <asp:BoundField DataField = "izquierdo" HeaderText = "IZQUIERDO"  />
                <asp:BoundField DataField = "fondo" HeaderText = "FONDO"  />
                <asp:BoundField DataField = "numPisos" HeaderText = "NUM PISOS"  />
                
                <asp:BoundField DataField = "dormitorio1" HeaderText = "DORMITORIO 1"    />
                <asp:BoundField DataField = "dormitorio2" HeaderText = "DORMITORIO 2"  />
                <asp:BoundField DataField = "dormitorio3" HeaderText = "DORMITORIO 3"     />
                <asp:BoundField DataField = "dormitorio4" HeaderText = "DORMITORIO 4"  />
                <asp:BoundField DataField = "banio1" HeaderText = "BAÑO 1"   />
                <asp:BoundField DataField = "banio2" HeaderText = "BAÑO 2"    />
                <asp:BoundField DataField = "banio3" HeaderText = "BAÑO 3"   />

                <asp:BoundField DataField = "sala" HeaderText = "SALA"    />
                <asp:BoundField DataField = "comedor" HeaderText = "COMEDOR"  />
                <asp:BoundField DataField = "cocina" HeaderText = "COCINA"    />
                
                <asp:BoundField DataField = "salaComedor" HeaderText = "SALA/COMEDOR"  />
                <asp:BoundField DataField = "salaComedorCocina" HeaderText = "SALA/COMEDOR/COCINA"    />
                <asp:BoundField DataField = "patio" HeaderText = "PATIO"  />
                <asp:BoundField DataField = "lavanderia" HeaderText = "LAVANDERIA"    />
                <asp:BoundField DataField = "PatioLavanderia" HeaderText = "PATIO/LAVANDERIA"  />
                <asp:BoundField DataField = "zonaComun" HeaderText = "ZONA COMUN" />
                <asp:BoundField DataField = "aires" HeaderText = "AIRES"   />
                <asp:BoundField DataField = "precio" HeaderText = "PRECIO"  ItemStyle-BackColor="LightGoldenrodYellow"  /> 
               <%--<asp:BoundField DataField = "observacion" HeaderText = "OBSERVACION"  ItemStyle-BackColor="LightGoldenrodYellow"/>--%>
               <asp:BoundField DataField = "comentario" HeaderText = "COMENTARIO"  />
                <asp:BoundField DataField = "activo" HeaderText = "ACTIVO"  />
               
            </Columns> 
        </asp:GridView>



        
            <asp:GridView ID="GridView6" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "numDocumento" HeaderText = "NUMERO"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "clienteStr" HeaderText = "CLIENTE"  />
                <asp:BoundField DataField = "formatoVenta" HeaderText = "FORMATO VENTA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "bancoFinan" HeaderText = "BANCO FINANCIAMIENTO"  />
                
                <asp:BoundField DataField = "cuentaAhorra" HeaderText = "CUENTA AHORRO"  />
                 <asp:BoundField DataField = "vendedor" HeaderText = "VENDEDOR" ItemStyle-BackColor="LightGoldenrodYellow" />
                 
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  />
                <asp:BoundField DataField = "UILocalizacion" HeaderText = "LOCALIZACION"  />
                <asp:BoundField DataField = "UI" HeaderText = "UNID. INMOBILIARIA"  />
                
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO ACT."  />
                <asp:BoundField DataField = "fechaStr" HeaderText = "FECHA SEP."  />
                <asp:BoundField DataField = "fechaVentaStr" HeaderText = "FECHA VENTA"  />
                <asp:BoundField DataField = "fechaAnulaStr" HeaderText = "FECHA ANUL."  />
                
                
                <%--<asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION" ItemStyle-BackColor="LightGoldenrodYellow"  />--%>
               <asp:BoundField DataField = "moneda" HeaderText = "MONEDA"  />
                <asp:BoundField DataField = "totalStr" HeaderText = "PRECIO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "totalPagoStr" HeaderText = "COBRADO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "saldoStr" HeaderText = "SALDO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
                
                <asp:BoundField DataField = "comentario" HeaderText = "COMENTARIO"  />
                
               
            </Columns> 
        </asp:GridView>



         <asp:GridView ID="GridView7" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "numero" HeaderText = "NUMERO"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "fecha" HeaderText = "FECHA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "localizacion" HeaderText = "UBICACION"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "UI" HeaderText = "UI"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "total" HeaderText = "PRECIO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
                <asp:BoundField DataField = "docCliente" HeaderText = "DOC IDENTIDAD"   ItemStyle-BackColor="AliceBlue" />
                <asp:BoundField DataField = "clienteStr" HeaderText = "CLIENTE"  ItemStyle-BackColor="AliceBlue"/>

                <asp:BoundField DataField = "formatoVenta" HeaderText = "FORMATO VENTA"  ItemStyle-BackColor="AliceBlue"/>
                <asp:BoundField DataField = "direccion" HeaderText = "DIRECCION" ItemStyle-BackColor="AliceBlue" />
                
                <asp:BoundField DataField = "telefono" HeaderText = "TELEFONO"  ItemStyle-BackColor="AliceBlue" />
                <asp:BoundField DataField = "email" HeaderText = "EMAIL"   ItemStyle-BackColor="AliceBlue"/>
                <asp:BoundField DataField = "idPregusnta1" HeaderText = "COMO SE ENTERO?"  ItemStyle-BackColor="AliceBlue"/>
                <asp:BoundField DataField = "vendedor" HeaderText = "VENDEDOR" ItemStyle-BackColor="AliceBlue" />
                
                <asp:BoundField DataField = "observacion" HeaderText = "OBSERVACION"  />
                <asp:BoundField DataField = "tipoIngreso" HeaderText = "TIPO INGRESO"  />
                <asp:BoundField DataField = "observacionFinan" HeaderText = "OBS.FINANCIERA"  />
                
       
       
        
            </Columns> 
        </asp:GridView>



          <asp:GridView ID="GridView8" runat="server"
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "numero" HeaderText = "NUMERO"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "fechaStr" HeaderText = "FECHA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "moneda" HeaderText = "MONEDA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "cuenta" HeaderText = "CUENTA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "banco" HeaderText = "BANCO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "totalStr" HeaderText = "TOTAL"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "cliente" HeaderText = "REFERENCIA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA REF."  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "UIstr" HeaderText = "UI REF."  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
        
        
            </Columns> 
        </asp:GridView>


        <asp:GridView ID="GridView9" runat="server" OnRowDataBound="GridView9_RowDataBound" 
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "ordenVenta" HeaderText = "ORDENVENTS"   />
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO"  />
                <asp:BoundField DataField = "cliente" HeaderText = "CLIENTE"  />
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  />
                <asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION"  />
                <asp:BoundField DataField = "UI" HeaderText = "UI"  />
                <asp:BoundField DataField = "codigo" HeaderText = "CODIGO"  />
                <asp:BoundField DataField = "concepto" HeaderText = "CONCEPTO" />
                <asp:BoundField DataField = "fecha" HeaderText = "FECHA"  />
                <asp:BoundField DataField = "hasta30Str" HeaderText = "HASTA  30 DIAS"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "hasta3060Str" HeaderText = "30 - 60 DIAS"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "hasta60masStr" HeaderText = "MAS DE  60 DIAS"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
        
        
            </Columns> 
        </asp:GridView>

      <%--OnRowDataBound="GridView9_RowDataBound"--%>

      <asp:GridView ID="GridView10" runat="server"  
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               
                <asp:BoundField DataField = "codigo" HeaderText = "CODIGO"   />
                <asp:BoundField DataField = "subFamilia" HeaderText = "SUBFAMILIA"  />
                <asp:BoundField DataField = "familia" HeaderText = "FAMILIA"  />
                <asp:BoundField DataField = "clase" HeaderText = "CLASE"  />
                <asp:BoundField DataField = "descripcion" HeaderText = "DESCRIPCION"  />
                <asp:BoundField DataField = "unidad" HeaderText = "UNID"  />

                <asp:BoundField DataField = "precioSinIGVStr" HeaderText = "PRECIO SINIGV"  />
                <asp:BoundField DataField = "precioConIGVStr" HeaderText = "PRECIO CONIGV"  />

                <asp:BoundField DataField = "numDocumentoStr" HeaderText = "ORDENCOMPRA"  />
                <asp:BoundField DataField = "proveedor" HeaderText = "PROVEEDOR"  />
                <asp:BoundField DataField = "ruc" HeaderText = "RUC"  />

                <asp:BoundField DataField = "fecha" HeaderText = "FECHA"  />
                <asp:BoundField DataField = "estructuraCosto" HeaderText = "ESTRUCTURACOMPRA"  />
                <asp:BoundField DataField = "tipoCambio" HeaderText = "TC"  />
                <asp:BoundField DataField = "autorizado" HeaderText = "AUTORIZADO"  />


       
            </Columns> 
        </asp:GridView>




             <asp:GridView ID="GridView11" runat="server" OnRowDataBound="GridView11_RowDataBound" 
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               <asp:BoundField DataField = "ItemStr" HeaderText = "ITEM"   />
                <asp:BoundField DataField = "ordenVenta" HeaderText = "ORDENVENTA"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "fechaSep" HeaderText = "FECHA SEP."  />
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  />
                <asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION"  />
                <asp:BoundField DataField = "UIStr" HeaderText = "UI"  />
                <asp:BoundField DataField = "cliente" HeaderText = "CLIENTE"  />
                <asp:BoundField DataField = "concepto" HeaderText = "FORMATO VENTA"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
                <asp:BoundField DataField = "banco" HeaderText = "BANCO" />
                <asp:BoundField DataField = "EsCuentaAhorro" HeaderText = "CUENTA AHORRO" />
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO"  />
                <asp:BoundField DataField = "vendedor" HeaderText = "VENDEDOR"  />
                <asp:BoundField DataField = "fechaVenStr" HeaderText = "FECHA VEN."  />
                <asp:BoundField DataField = "totalStr" HeaderText = "PRECIO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "totalPagoStr" HeaderText = "COBRADO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                <asp:BoundField DataField = "saldoStr" HeaderText = "SALDO"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
            </Columns> 
        </asp:GridView>




           <asp:GridView ID="GridView12" runat="server" OnRowDataBound="GridView12_RowDataBound" 
          AutoGenerateColumns="false" Font-Names = "Arial"  RowStyle-Font-Size="Smaller" 
          HeaderStyle-Font-Size="Smaller"  Font-Size="Small">
            <Columns>
               <asp:BoundField DataField = "ItemStr" HeaderText = "ITEM"   />
               <asp:BoundField DataField = "fechaAnulacion" HeaderText = "FECHA ANULACION"  ItemStyle-BackColor="LightGoldenrodYellow" />
               
                <asp:BoundField DataField = "ordenVenta" HeaderText = "ORDENVENTA"  ItemStyle-BackColor="LightGoldenrodYellow" />
                <asp:BoundField DataField = "cliente" HeaderText = "CLIENTE"  />
                <asp:BoundField DataField = "etapa" HeaderText = "ETAPA"  />
                <asp:BoundField DataField = "localizacion" HeaderText = "LOCALIZACION"  />
                <asp:BoundField DataField = "UIStr" HeaderText = "UI"  />
                <asp:BoundField DataField = "estado" HeaderText = "ESTADO"  />
                <asp:BoundField DataField = "fechaSeparacion" HeaderText = "FECHA SEP."  />
                <asp:BoundField DataField = "fechaVentaStr" HeaderText = "FECHA VEN."  />
                
                <asp:BoundField DataField = "usuarioAnula" HeaderText = "USUARIO ANULACION"  />
                
                <asp:BoundField DataField = "totalStr" HeaderText = "TOTAL DEVOLUCION"  ItemStyle-BackColor="LightGoldenrodYellow"/>
                
                
            </Columns> 
        </asp:GridView>

    </form>
</body>
</html>
